<?php
include '../c/config.php';
$mysqli = new mysqli($dbhost, $dbuser, $dbpwd, $dbName);
if (!$mysqli->set_charset("utf8")) {printf("Error loading character set utf8: %s\n", $mysqliTwo->error);}
$index=2;
$query=$mysqli->query("SELECT * FROM play where jid=1 ");
$jName=array(
    1=>'一等奖',
    2=>'吃货奖',
    3=>'免单奖',
    4=>'立减2元'
);
while ($list=$query->fetch_assoc()){
	$name=$avatar='';
	$queryU=$mysqli->query("SELECT * FROM users where openid='".$list['openid']."' limit 0,1");
	if($queryU->num_rows>0){
	    $getU=$queryU->fetch_array();
	    echo base64_decode($getU['nickname']);
	    var_dump($getU);
	    echo "<br/>";
	    
	}
	
	 
					 
					
} 
$mysqli->close();

 